G
Guest
Converting Text files to Excel sheets with specific formatting
Hello, I have an issue with .txt files and excel. I have a text file that
is outputted from our mainframe that needs to be converted to an exact excel
format. The text output has tons of information that is not needed and hides
pertinent information within long strings of useless data. The text appears
something like this:
199230989814890987477912309809830972004090409703877891023478700011000234
The information that I would need out of the same string would be the
following parts:
19923098981489098747791230980983097\\\\\20040904\\\\\0970387789102347870001\\\\\\\1000234\\\\\
the 20040904 which is the date and 1000234 which is a test account number.
The text file consists of about 20 to 25 strings like this per line. Each
value needed would have to automatically fill a cell in a named column.
I’m not big on excel or data automation so I’m here for some guidance please.
Thanks
Hello, I have an issue with .txt files and excel. I have a text file that
is outputted from our mainframe that needs to be converted to an exact excel
format. The text output has tons of information that is not needed and hides
pertinent information within long strings of useless data. The text appears
something like this:
199230989814890987477912309809830972004090409703877891023478700011000234
The information that I would need out of the same string would be the
following parts:
19923098981489098747791230980983097\\\\\20040904\\\\\0970387789102347870001\\\\\\\1000234\\\\\
the 20040904 which is the date and 1000234 which is a test account number.
The text file consists of about 20 to 25 strings like this per line. Each
value needed would have to automatically fill a cell in a named column.
I’m not big on excel or data automation so I’m here for some guidance please.
Thanks