It's a regular expression question

Help Studio
, ,
1

In a sentence that repeats over and over again

I’d like to remove only the part I want.
Is there a regular expression that expresses that part?

The part that I don’t want to do is
( USD ~~ / KRW ~~ )

~~
(KRW)
~~

It is.

~~ contains any number.

Below are some of the repeated sentences.

B/L_JTL240425001
INCOTERMS_FOB

OCEAN_FREIGHT_CHARGE USD 340.00 340.00 1,389.30 472,362

TERMINAL_HANDLING_CHARG KRW 180,000 1.00 1.00 180,000

WHARFAGE_CHARGE KRW 2,742 1.00 1.00 2,742

CONTAINER_CLEARANCE_CHA KRW 50,000 1.00 1.00 50,000

PORT_SATETY_MAINTENACE KRW 474 1.00 1.00 474

DOCUMENT_FEE KRW 40,000 1.00 1.00 40,000

LOW_SULPHUR_SURCHARGE USD 200.00 200.00 1,389.30 277,860

TRUCKING_CHARGE KRW 415,000 1.00 1.00 415,000

중량할증료 KRW 117,600 1.00 1.00 117,600

( USD540.00 / KRW805,816 )

1,556,038
(KRW)
1,556,038

B/L_JTL240406011
INCOTERMS_FOB

OCEAN_FREIGHT_CHARGE USD 340.00 340.00 1,392.20 473,348

TERMINAL_HANDLING_CHARG KRW 180,000 1.00 1.00 180,000

WHARFAGE_CHARGE KRW 2,742 1.00 1.00 2,742

CONTAINER_CLEARANCE_CHA KRW 50,000 1.00 1.00 50,000

PORT_SATETY_MAINTENACE KRW 474 1.00 1.00 474

DOCUMENT_FEE KRW 40,000 1.00 1.00 40,000

LOW_SULPHUR_SURCHARGE USD 200.00 200.00 1,392.20 278,440

TRUCKING_CHARGE KRW 415,000 1.00 1.00 415,000

세관검사료 KRW 238,380 1.00 1.00 238,380

( USD540.00 / KRW926,596 )

1,678,384
(KRW)
1,678,384

B/L_NGSE24041421
INCOTERMS_FOB

OCEAN_FREIGHT_CHARGE USD 200.00 200.00 1,391.50 278,300

TERMINAL_HANDLING_CHARG KRW 180,000 1.00 1.00 180,000

CONTAINER_CLEARANCE_CHA KRW 50,000 1.00 1.00 50,000

WHARFAGE_CHARGE KRW 9,504 1.00 1.00 9,504

HANDLING_CHARGE USD 40.00 40.00 1,391.50 55,660

DOCUMENT_FEE KRW 40,000 1.00 1.00 40,000

TRUCKING_CHARGE KRW 465,000 1.00 1.00 465,000

HANDLING_CHARGE USD 50.00 50.00 1,391.50 69,575

( USD290.00 / KRW744,504 )

1,148,039
(KRW)
1,148,039

2

Hi @sssim4567

Your data is quite confusing could you give the proper data which has to remove and Input data and required output data.

3

@sssim4567

Please be more specific about your requirement.Your input and output should be specific

4

It is a pattern that repeats from B/L to B/L.

The last part of the pattern (USD ~ / KRW ~)

~,~
(KRW)
~,~

*~ means a number.

I want to express this part as a regular expression
This is for deletion.

5

@sssim4567

\( USD\d+(\.\d+)? \/ KRW\d+(,\d+)* \)|\d+(,\d+)*\s?\(KRW\)\s?\d+(,\d+)*

<Assign>
    <To>outputText</To>
    <Value>System.Text.RegularExpressions.Regex.Replace(inputText, "\( USD\d+(\.\d+)? \/ KRW\d+(,\d+)* \)|\d+(,\d+)*\s?\(KRW\)\s?\d+(,\d+)*", "")</Value>
</Assign>

Try this hope it helps

6

It is a pattern that repeats from B/L to B/L.

The last part of the pattern (USD ~ / KRW ~)

~,~
(KRW)
~,~

*~ means a number.

I want to express this part as a regular expression
This is for DELETE

7

~,~
(KRW)
~,~

*~ means a number.

This part is still not removed.

And in some patterns

( USD1,020.00 / KRW2,020,512 )

This has not been removed either.

8

@sssim4567

\( USD\d{1,3}(,\d{3})*(\.\d+)? \/ KRW\d{1,3}(,\d{3})* \)|\d{1,3}(,\d{3})*\s?\(KRW\)\s?\d{1,3}(,\d{3})*

try this hope works

9

~,~,~
(KRW)
~,~,~

*~ means a number.

This part is still not removed.

I think only this part needs to be removed.