Hi,

I need to Seperate a text from number by single or double space.

It should be seperate only when number having a immediate text with a . (Dot only) between the number and text.

It should not seperate on a numbers only (EX: 1.362.31)

Example:

Input : 1.aasdfasdfa


Output : 1.aasdfasdfa (Space is there after 1. )

Input: 1.3671.351
Output: Input: 1.3671.351 (No changes)

Input: 2.sdfasdfssd
Output: 2.sdfasdfssd (Space is there after 2. )

Is this automated by a macro or using wildcard find and replace.

Your help is highly appreciated....

Attached Files

test.docx (58.3 KB, 7 views)

Find and Replace
Find: .([a-z])
Replace with: . \1
Wildcards On

Note there is a space after the period in the replace with value.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Hi,

It works well only with english (a-z), (A-Z) am working with different languages, is there any other source to get a double space after . otherthan to the numbers.

Condition is: . after other than numbers will get 2 spaces irrespective of language.

. after numbers (0-9) shouldnt be changed only changed other than numbers

EX:

Input:

1.Środki pieniężne i ich ekwiwalenty
2.持高侍伴资产
3.一年内到期的年流动资产
4.Вземания от свързани предприятия
5.Вземания от клиенти и доставчици

4.336.959.210.50

Output:

1. Środki pieniężne i ich ekwiwalenty
2. 持高侍伴资产
3. 一年内到期的年流动资产
4. Вземания от свързани предприятия
5. Вземания от клиенти и доставчици

4.336.959.210.50

Your Help is Highly appreciated and thanks in advance, please do the needful...

OK then try
Find: .([!0-9 ])
Replace with: . \1
wildcards on

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia