Member Avatar for Chandrai
Chandrai 0 Newbie Poster 
INSERT [table].[Region] ([RegionID], [RegionDesc]) VALUES (1, N'East')
INSERT [table].[Region] ([RegionID], [RegionDesc]) VALUES (2, N'West')
INSERT [table].[Region] ([RegionID], [RegionDesc]) VALUES (3, N'North')
INSERT [table].[Region] ([RegionID], [RegionDesc]) VALUES (4, N'South')

I have a text file like above. From the above insert statements i want to write code so that it turns into a python list thing like. Output should be

[table].[Region]:-
[RegionID]   [RegionDesc]
      1                   N'East
      2                   N'West
      3                   N'North

how to achieve this kind of result. plz help

Edited by Chandrai
  • 1 Contributor
  • 0 Replies
  • 148 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.