Subscribe to this thread
Home - General / All posts - replace text
cassini101 post(s)
#27-Dec-16 17:08

Hello everybody,

Do you have a quick method to replace spaces with dashes, as in the following text:

HAPPY HOLIDAYS TO ALL

---> BONNES-FETES-A-ALL

I have no knowledge in script. thank you

ColinD

2,081 post(s)
#27-Dec-16 20:04

Maybe too obvious for what you need but Ctrl H Find<space>/Replace<dash>?


Aussie Nature Shots

bdg63 post(s)
#29-Dec-16 14:21

That works fine for a single or or a few changes. An update query is probably the way to go for doing in mass.

Create a query component, populate with the text below, substituting your Drawing or Table name for [Drawing] and your column name for [Column]. All spaces in [Column] will be replaced by dashes.

The language translation is up to you (Happy -> Bonne, etc).

code

update [Drawing]

set [Column] = Replace([Column]," ","-")

cassini101 post(s)
#30-Dec-16 15:12

Hello Colin,

very easy, thnaks :)

Manifold User Community Use Agreement Copyright (C) 2007-2021 Manifold Software Limited. All rights reserved.