Multiple separators in a file...

[aris_hidalgo]

Hello Experts,

I have a file which has mutiple kinds of separator like '|', tab, etc. So,

how do I split my string table since I do not the kind of separator the file is using during

runtime.

Thank you guys and take care!

[Former Member]

Hi viraylab,

Can you explain the problem in-extenso?

Regards,

Nidhi Kothiyal

[aris_hidalgo]

The file is generated by a legacy system and I need to uplaod it. The problem is that for some files, they have 2 or more kinds of delimiters like '|' and ','. So I need to do a dynamic checking of delimiter so I can split it correctly.

[Former Member]

are you using LSMW?

if yes then there you can write your code to convert all separators to one particular type.

if not,

then just after gui_upload you can put your code to replace all type of delimiter by a single type.

[Former Member]

search and replace all separators by a single separator.

then use this separator for all files.

[former_member188827]

is the file getting generated automatically?is your program running in background?if no provide a separator field on selection screen so that user can enter separator on screen and you can split your text accordingly.

[Former Member]

Firstly,

i think you should you command FIND to find for each separator, then replace each ones by other same separator (for instance replace all |, tab by '#').

Secondly,

split your string to table.

Hope this help

[Former Member]

Hi,

Add, remove all occurences ....

Thanks,

Krishna.