Remove Spaces if match with keywords

[Rajesh T]

Hi Team,

Need your help to remove spaces based on keywords matching;

Example:
CAG000099 1ORCOMM
CAG000099 1ORCOMM
CAG000099 2ORCOMB
CAG000099 3COMM
CAG000099 1COMB

If the above rows match with keyword COM,reduce the spaces(Currency 3spaces,i want only 1 space) in between above two words.

Expected:
CAG000099 1ORCOMM(3 Spaces)
CAG000099 1ORCOMM(1 Space)

Thank you in advance.

[rinku singh]

here is no Currency symbol instead
hi rajesh you can speak hindi

[rinku singh]

@Rajesh-T said in Remove Spaces if match with keywords:

between above two words.

find 3 spaces in your name using rexex
find what : Rajesh\s\s\sT

[Rajesh T]

Hi @gurikbal-singh ,

No ,only english…Its currently typo mistake.

I have 3 spaces in between CAG000099 and 1ORCOMM,
Requied only 1 space between CAG000099 and 1ORCOMM,

[rinku singh]

@Rajesh-T said in Remove Spaces if match with keywords:

CAG000099 and 1ORCOMM

find what :CAG000099\s\s\s1ORCOMM
replace with :CAG000099\s1ORCOMM

using regex

[Rajesh T]

hi @gurikbal-singh

1ORCOMM can be change in few lines,either it will be 1 COMM or 2 COMM or 2ORCOMM but COM is common in all keywords.
How we handle in this case?

[rinku singh]

@gurikbal-singh said in Remove Spaces if match with keywords:

where in example every line starts with CAG000099

find what :^CAG000099\s\s\s
replace with :^CAG000099\s

[Rajesh T]

hi @gurikbal-singh

Its exactly looks like below

AG00001FF363611113636111010103G16CAF000011 1ORCOMM

AG00286FF004409580044095010100C17AAF002800 2COMB
AG00286FF004372480043724010100C17AAF002800 2COMVC2

[rinku singh]

replace \s\s\s with \s

[Rajesh T]

Thank you @gurikbal-singh .
The information you provided matches few conditions.