Page 1 of 1
I need help here
Posted: 06 Oct 2011 23:26
by renzlo
Hi All,
I want to split below contents of source.txt,
Code: Select all
0.99Flakes in oil
2.99Safe Guard
0.0035Fleeming
12.999Tissue Holder
123.25-Oasis
1245.88 Amnna
The numbers are price and the alpha are product name:
I want the output to be like this(tab delimited):
Code: Select all
Price Product Name
0.99 Flakes in oil
2.99 Safe Guard
0.0035 Fleeming
12.999 Tissue Holder
123.25 Oasis
1245.88 Amnna
I tried everything I know but no luck for me, is there a way?
Re: I need help here
Posted: 07 Oct 2011 05:13
by colargol
Hi
I think this should work. I don't know if there is a better solution...
Code: Select all
setlocal ENABLEDELAYEDEXPANSION
for /f "usebackq tokens=*" %%a in (`type "file.txt"`) do (
set line=%%a
for /f "tokens=* delims=1234567890." %%b in ("!line!") do (set product=%%b)
call set "price=%%line:!product!=%% "
for /f "tokens=* delims= " %%b in ("!product!") do (set product=%%b)
echo !price:~0,16!!product!
)
assuming price won't exceed 16 chars and products won't have special chars like ! ^ =
Re: I need help here
Posted: 07 Oct 2011 06:21
by renzlo
thanks for the reply dude. I'll try this one. If you don't mind, kindly explain this line:
Code: Select all
call set "price=%%line:!product!=%%
Re: I need help here
Posted: 07 Oct 2011 12:49
by colargol
sorry for my bad english, it's not always easy to explain.
This is just a string substitution (
see here)
In each line, the product is replaced with nothing, so we get the price
I used call because it allows to use a variable in the substitution.
Not sure I'm clear.
