Separating characters in a text

[strusiceltex]

This is my problem:

The accounts that are separated gives '.. ' Means > = and < = while those preceded by | ' are = to the account indicated.

what function should I use?

[arvind_patil]

Hi Antonello,

Use PURGECHAR() function it may help you.

Thanks,

Arvind Patil

[strusiceltex]

Thank , i make a test -

Antonello Strusi

Celtex s.p.a. Tel. 0583 27 41

Via Trav. Del Marginone, 21/23 - Loc. il Teso Cell.334 6885519

55015 Montecarlo (LU) e-mail: antonello.strusi@celtex.it<mailto:antonello.strusi@celtex.it>

P Rispetta l'ambiente: se non ti è necessario, non stampare questa mail.

Le informazioni contenute nella presente comunicazione e i relativi allegati possono essere riservati e sono, comunque, destinate esclusivamente alle persone o alla Società sopraindicati. La diffusione, distribuzione e/o copiatura del documento trasmesso da parte di qualsiasi soggetto diverso dal destinatario è proibita, sia ai sensi dell’art. 616 c.p. , che ai sensi del D.Lgs. n. 196/2003. Se avete ricevuto questo messaggio per errore, vi preghiamo di distruggerlo e di informarci immediatamente per telefono allo 0583 2741 o inviando un messaggio all’indirizzo e-mail info@celtex.it<mailto:info@celtex.it>

The information in this e-mail (which includes any files transmitted with it) is confidential and may also be legally privileged. It is intended for the addressee only. Access to this e-mail by anyone else is unauthorised. It is not to be relied upon by any person other than the addressee, except with our prior written approval. If no such approval is given, we will not accept any liability (in negligence or otherwise) arising from any third party acting, or refraining from acting on such information. Unauthorised recipients are required to maintain confidentiality. If you have received this e-mail in error please notify us immediately, destroy any copies and delete it from your computer system. Any use, dissemination, forwarding, printing or copying of this e-mail is prohibited. Copyright in this e-mail and any document created by us will be and remain vested in us and will not be transferred to you. We assert the right to be identified as the author of and to object to any misuses of the contents of this e-mail or such documents.

Da: Arvind Patil

Inviato: giovedì 21 dicembre 2017 08:47

A: Antonello Strusi

Oggetto: Re: - Separating characters in a text

[sunny_talwar]

You want to replace '..' with >= or <= and '|' with '='? The second one is easy as it is a one to one change... but for the first one, how do we know where to use >= and where to use <=

[strusiceltex]

Thank

[MarcoWedel]

please provide some sample data (as text instead of an image) and your expected result.

thanks

regards

Marco