load comma and space separated fields

[Anonymous]

hi

Data is in text file. I converted into csv and fields are separated by commas and some are with spaces.

how can i extract data as correct fields, which has combination of comma and space separated fields?

[iktrayanov]

Can you share a sample of your data?

[Anonymous]

here is the file.. open in note pad .. convert into csv..

[#4]

Hi Praveena, First you need to load file with any delimiter and then creates the fields with subfield function.

Please find the attached file for reference.

[Anonymous]

Hi Dathu,

Thanks but you see irregularity of data representing in fields on  6th row from last . That's data structure problem.. I guess we cant fix it until data is in proper format because we can able to look data and may fix in one file here but not in all..

[#6]

First Solution would be an extension to Dathu's solution... Write a loop to check for space or ',' using subfield to write values to each column

Second one is to clean up your data. if you have etl tools in development process that should take care of it. else you might have to do it manually.

[#7]

If you get the all the files and look into into files. After that you can write what you need and what is the o/p.