Hi,

I have and input text file containing data in the following format:

9.00; 1.00-; .00000;00; 25.00; 672;SC;006700014414841;107/09/14;
19.00; 22.00-; .00000;00; 205.00;
672;SC;006700014414841;107/09/14;

Is there any easy way to shift the negative sign (-) in the second column to
left? Output text should be like this:

9.00; -1.00; .00000;00; 25.00; 672;SC;006700014414841;107/09/14;
19.00; -22.00; .00000;00; 205.00;
672;SC;006700014414841;107/09/14;

Is there any easy way using regex or any search-replace technique?

Any help much appreciated.

Thanks,
PN

Bin wrote:

> Hi,
>
> I have and input text file containing data in the following format:
>
> 9.00; 1.00-; .00000;00; 25.00; 672;SC;006700014414841;107/09/14;
> 19.00; 22.00-; .00000;00; 205.00;
> 672;SC;006700014414841;107/09/14;
>
> Is there any easy way to shift the negative sign (-) in the second column to
> left? Output text should be like this:
>
> 9.00; -1.00; .00000;00; 25.00; 672;SC;006700014414841;107/09/14;
> 19.00; -22.00; .00000;00; 205.00;
> 672;SC;006700014414841;107/09/14;
>
> Is there any easy way using regex or any search-replace technique?
>
> Any help much appreciated.
>
> Thanks,
> PN
>

Easy enough... What do you want to do with the result? Create a 2nd
file with it? Overwrite the original? I'm assuming this is
line-per-line, and the general format doesn't change?

I've got something, but it isn't pretty yet...

PSH> $string
9.00; 1.00-; .00000;00; 25.00;
672;SC;006700014414841;107/09/14;

PSH> $string|`
foreach-object{$split=$split=$string.split(";")
$split[0]+";-"+$_.split(";")[1].trimend("-1").trimstart()}
9.00;-1.00

Ain't pretty, and I loose some of the spacing. A regex would be neater.

How do the original spaces fit into all of this? Do they need to be
preserved?

Marco

--
Microsoft MVP - Windows PowerShell
http://www.microsoft.com/mvp

PowerGadgets MVP
http://www.powergadgets.com/mvp

Blog:
http://marcoshaw.blogspot.com

Mine is no pretty too, and there are still open questions as Marco wrote

$text="9.00; 1.00-; .00000;00; 25.00; 672;SC;006700014414841;107/09/14; 19.00;
22.00-; .00000;00; 205.00; 672;SC;006700014414841;107/09/14;"
$text.split(";") | foreach {$_=$_.trim(); if(($_[-1]) -eq "-"){ $_= ("-"+$_.replace("-",""))
}$_}

9.00
-1.00
..00000
00
25.00
672
SC
006700014414841
107/09/14
19.00
-22.00
..00000
00
205.00
672
SC
006700014414841
107/09/14

Regex is definitely a better solution.


Shay
http://scriptolog.blogspot.com

> Hi,
>
> I have and input text file containing data in the following format:
>
> 9.00; 1.00-; .00000;00; 25.00;
> 672;SC;006700014414841;107/09/14; 19.00; 22.00-; .00000;00;
> 205.00; 672;SC;006700014414841;107/09/14;
>
> Is there any easy way to shift the negative sign (-) in the second
> column to left? Output text should be like this:
>
> 9.00; -1.00; .00000;00; 25.00;
> 672;SC;006700014414841;107/09/14; 19.00; -22.00; .00000;00;
> 205.00; 672;SC;006700014414841;107/09/14;
>
> Is there any easy way using regex or any search-replace technique?
>
> Any help much appreciated.
>
> Thanks,
> PN

>> Is there any easy way to shift the negative sign (-) in the second
>> column to left? Output text should be like this:
>>
>> 9.00; -1.00; .00000;00; 25.00;
>> 672;SC;006700014414841;107/09/14;
>> 19.00; -22.00; .00000;00; 205.00;
>> 672;SC;006700014414841;107/09/14;

Here's one way:

PSH>get-content data.txt|foreach-object{$_ -replace "(\d*\D*\d*)-;",'-$1;'}
9.00; -1.00; .00000;00; 25.00;
672;SC;006700014414841;107/09/14;
19.00; -22.00; .00000;00; 205.00;
672;SC;006700014414841;107/09/14;

(Pipe to out-file to save the output to a new file.)

(Thanks Lee Holmes for all the details you put in your books.)

Marco

# output to screen
(get-content file.txt) -replace '(\d+\.\d+)-', '-$1'

# output to new file
set-content newFile.txt ((get-content file.txt) -replace '(\d+\.\d+)-', '-$1')

--
Kiron

On Oct 12, 6:15 am, Bin <B...@xxxxxx> wrote:

> Hi,
>
> I have and input text file containing data in the following format:
>
> 9.00; 1.00-; .00000;00; 25.00; 672;SC;006700014414841;107/09/14;
> 19.00; 22.00-; .00000;00; 205.00;
> 672;SC;006700014414841;107/09/14;
>
> Is there any easy way to shift the negative sign (-) in the second column to
> left? Output text should be like this:
>
> 9.00; -1.00; .00000;00; 25.00; 672;SC;006700014414841;107/09/14;
> 19.00; -22.00; .00000;00; 205.00;
> 672;SC;006700014414841;107/09/14;
>
> Is there any easy way using regex or any search-replace technique?
>
> Any help much appreciated.
>
> Thanks,
> PN

One more, just for completeness. Update the file "in place":

${C:file.txt} = ${C:file.txt} -replace "(\d+\.\d+)-", "-$1"

This assumes the file is in the current working directory on the C:
drive.

Jeff