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

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

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

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.