Adding a Line Break to Find/Replace

Hello,

I am trying to use find replace to add a line as part of the find/replace.  For example, the original text node looks like this:

AREA FILL = 354 SQ. FT.

And I would like to get it to look like this:

AREA FILL

STAGE 1 = 354 SQ. FT

Is there a way to accomplish this?

Thanks,

-Adam

Parents
  • You said they are text  nodes I dont think "find replace" works with text nodes?

    Select all the text nodes and  us the drop tool to make it back into plain text.

    I dont  think you can add a carriage return with find replace tool which I think is chr(13) in ascii or line feed chr(10)

    or you may find the regular expressions feature to do it but I not any success with the  regular expressions  or any  useful help on it...

    but  if say you used find replace AREA FILL  VBA or Basic  you could hijack the  find replace tool to replace AREA FILL= with  "AREA FILL" Chr(13) + "STAGE 1 =354 SQ FT" 

    personally I would find this very time consuming to get the  code to work

    So I would for a lot of these  say 100 plus instances use the free export text macro I have mentioned this forum  before  to get the  coordinates and text it self into excel

    then use excel to create offset value of 2  text heights  for the second line of text and add the STAGEX1=354XSQXFT as a separate piece of text  below the area  fill text

    I use the X for a  reason...will explain later

    then on new level with same text attributes use import coordiantes tool from msnt ( xyz tool) to import the  new table that contains STAGEX1=354XSQXFT pieces of text

    using the TXYZ  option .. now we can just  use the find replace Z with a space  because the  import tool doesnt  like spaces or commas havent tried  periods  but you may want to put say Z in place of  periods just in case and run the  find replace again..to add the  periods for Zs

    this sounds far more difficult than it is as  excel has great auto fill and equations to do the offset distance for x & y 

    Lorys

    Started msnt work 1990 - Retired  Nov 2022 ( oh boy am I old )

    But was long time user V8iss10 (8.11.09.919) dabbler CE  update 16 (10.16.00.80) 

    MicroStation user since 1990 Melbourne Australia.
    click link to PM me 

Reply
  • You said they are text  nodes I dont think "find replace" works with text nodes?

    Select all the text nodes and  us the drop tool to make it back into plain text.

    I dont  think you can add a carriage return with find replace tool which I think is chr(13) in ascii or line feed chr(10)

    or you may find the regular expressions feature to do it but I not any success with the  regular expressions  or any  useful help on it...

    but  if say you used find replace AREA FILL  VBA or Basic  you could hijack the  find replace tool to replace AREA FILL= with  "AREA FILL" Chr(13) + "STAGE 1 =354 SQ FT" 

    personally I would find this very time consuming to get the  code to work

    So I would for a lot of these  say 100 plus instances use the free export text macro I have mentioned this forum  before  to get the  coordinates and text it self into excel

    then use excel to create offset value of 2  text heights  for the second line of text and add the STAGEX1=354XSQXFT as a separate piece of text  below the area  fill text

    I use the X for a  reason...will explain later

    then on new level with same text attributes use import coordiantes tool from msnt ( xyz tool) to import the  new table that contains STAGEX1=354XSQXFT pieces of text

    using the TXYZ  option .. now we can just  use the find replace Z with a space  because the  import tool doesnt  like spaces or commas havent tried  periods  but you may want to put say Z in place of  periods just in case and run the  find replace again..to add the  periods for Zs

    this sounds far more difficult than it is as  excel has great auto fill and equations to do the offset distance for x & y 

    Lorys

    Started msnt work 1990 - Retired  Nov 2022 ( oh boy am I old )

    But was long time user V8iss10 (8.11.09.919) dabbler CE  update 16 (10.16.00.80) 

    MicroStation user since 1990 Melbourne Australia.
    click link to PM me 

Children
No Data