# \#text **URL:** https://forum.uipath.com/tag/text/1775.md [Latest](https://forum.uipath.com/latest.md) · [Categories](https://forum.uipath.com/categories.md) · [Tags](https://forum.uipath.com/tags.md) --- ## [How to delete rows in a text document](https://forum.uipath.com/t/how-to-delete-rows-in-a-text-document/5664695)
**Author:** [@alexis.mendoza.rpa](https://forum.uipath.com/u/alexis.mendoza.rpa)\ **Replies:** 2\ **Last updated:** [October 19, 2025, 12:33pm UTC](https://forum.uipath.com/t/how-to-delete-rows-in-a-text-document/5664695 "2025-10-19T12:33:15Z")
I have the following issue: I have a text document that I need to transform into a data table. The problem is that the first two rows or lines contain unnecessary text for the brand and date. How can I remove the text … --- ## [How to generate data table using text from a .tsv file?](https://forum.uipath.com/t/how-to-generate-data-table-using-text-from-a-tsv-file/747738)
**Author:** [@mishra.suraj](https://forum.uipath.com/u/mishra.suraj)\ **Replies:** 2\ **Last updated:** [June 16, 2024, 4:33am UTC](https://forum.uipath.com/t/how-to-generate-data-table-using-text-from-a-tsv-file/747738 "2024-06-16T04:33:11Z")
Hello Everyone, I have a .tsv file(not csv) and I want to convert this file to excel file. I tried doing it through rename file activity but I wasn’t as well as I tried doing it by first reading the .tsv file using Read… --- ## [Actualizacion Uipath](https://forum.uipath.com/t/actualizacion-uipath/774459)
**Author:** [@morenoguadalupe.98](https://forum.uipath.com/u/morenoguadalupe.98)\ **Replies:** 1\ **Last updated:** [October 20, 2024, 3:32am UTC](https://forum.uipath.com/t/actualizacion-uipath/774459 "2024-10-20T03:32:11Z")
Necesito ayuda, con la nueva actualizacion la opcion de “escribir en” ya no se encuentra, ya que al hacer el ejemplo en escrbir en algo basico como calculadora no se encontraba, y la oopcion de type into no la reconoce, … --- ## [Make every first Word letter Capital](https://forum.uipath.com/t/make-every-first-word-letter-capital/774122)
**Author:** [@agustinarbiza](https://forum.uipath.com/u/agustinarbiza)\ **Replies:** 2\ **Last updated:** [October 17, 2024, 3:18pm UTC](https://forum.uipath.com/t/make-every-first-word-letter-capital/774122 "2024-10-17T15:18:33Z")
Y para forzar que solo la primera letra de las palabras esté en mayuscula? --- ## [特定のアプリを「テキスト(notepad.exe)」で開きたい](https://forum.uipath.com/t/notepad-exe/749616)
**Author:** [@AAAbbb](https://forum.uipath.com/u/AAAbbb)\ **Replies:** 3\ **Last updated:** [July 3, 2024, 11:20pm UTC](https://forum.uipath.com/t/notepad-exe/749616 "2024-07-03T23:20:55Z")
特定のアプリを「テキスト(notepad.exe)」で開きたいのですが、やりかたを知ってる方はいらっしゃいますでしょうか？ （例、Main.zamlを「notepad.exe」で開く等） ※開くアプリはファイルパスで指定、Uipathのバージョン：2023.10.4 Main.zamlで試してるのですが、うまく行きません(＝テキストではなく、Uipathで開いてしまう…)。 ご存じの方がいらっしゃれば、教えて頂けますと助かります… --- ## [PDFを読み込むと文字化けしてしまう](https://forum.uipath.com/t/pdf/745256)
**Author:** [@curry](https://forum.uipath.com/u/curry)\ **Replies:** 3\ **Last updated:** [June 12, 2024, 7:26am UTC](https://forum.uipath.com/t/pdf/745256 "2024-06-12T07:26:40Z")
【問題】 機密情報が記載されているためPDFは共有できないのですが、 そのPDFを「UiPath.PDF.Activities」パッケージ（ver 3.19.1）の 「ReadPDFText」アクティビティを使用すると文字化けしてしまいます。 文字化けせずに取得する方法はないでしょうか。 【試したこと】 ①VB.netの「Spire.Pdf」による文字列に変換 →上記ライブラリのインストール方法が分からず断念 ②文字コー… --- ## [Convert text file data to Excel](https://forum.uipath.com/t/convert-text-file-data-to-excel/745842)
**Author:** [@vicki1995](https://forum.uipath.com/u/vicki1995)\ **Replies:** 2\ **Last updated:** [June 6, 2024, 10:06am UTC](https://forum.uipath.com/t/convert-text-file-data-to-excel/745842 "2024-06-06T10:06:51Z")
Hello Friends, I have text file and assign as string From string i need to create proper excel like below, String is : "PatientName: HARY, COLE R PEARY, SOLE R ROY, EALE R MemberID: 13781902, 97819013, 81981902 … --- ## [Excel/Text File Obstacle](https://forum.uipath.com/t/excel-text-file-obstacle/726391)
**Author:** [@Jackson\_Hew](https://forum.uipath.com/u/Jackson_Hew)\ **Replies:** 10\ **Last updated:** [March 14, 2024, 5:34am UTC](https://forum.uipath.com/t/excel-text-file-obstacle/726391 "2024-03-14T05:34:06Z")
Hi All, I am in need to create an automation for the following below:- Import the latest up to date .txt file into an excel (.csv - with column headers). Always choose the latest date of .txt file to import from. \*E… --- ## [Issues with Read pdf text in UI path](https://forum.uipath.com/t/issues-with-read-pdf-text-in-ui-path/718297)
**Author:** [@Christodoulos](https://forum.uipath.com/u/Christodoulos)\ **Replies:** 4\ **Last updated:** [February 15, 2024, 9:18am UTC](https://forum.uipath.com/t/issues-with-read-pdf-text-in-ui-path/718297 "2024-02-15T09:18:19Z")
Greetings Community, I am having trouble when reading some pdf documents in my process using the Get pdf text from pdf activities dependency as well as the document understanding activity. The issue is that some pdf se… --- ## [Format unstructured text in structured and create a datatable with three columns](https://forum.uipath.com/t/format-unstructured-text-in-structured-and-create-a-datatable-with-three-columns/708562)
**Author:** [@Dhruvi\_Arumugam](https://forum.uipath.com/u/Dhruvi_Arumugam)\ **Replies:** 18\ **Last updated:** [December 27, 2023, 12:10pm UTC](https://forum.uipath.com/t/format-unstructured-text-in-structured-and-create-a-datatable-with-three-columns/708562 "2023-12-27T12:10:12Z")
Hi Everyone, Can please someone help me in achieving the formatted text required :slight\_smile: . I am facing issues. Below is the file of the input text: Input.TXT (3.6 KB) Below is the expected output I want … --- ## [Specific choices with LİNQ](https://forum.uipath.com/t/specific-choices-with-linq/708812)
**Author:** [@Bedirhan\_Ozkan](https://forum.uipath.com/u/Bedirhan_Ozkan)\ **Replies:** 8\ **Last updated:** [December 27, 2023, 8:26am UTC](https://forum.uipath.com/t/specific-choices-with-linq/708812 "2023-12-27T08:26:29Z")
How can I choose between account amount and ron with linq? --- ## [Auto Complete Variable with Default Value](https://forum.uipath.com/t/auto-complete-variable-with-default-value/708639)
**Author:** [@aliaga](https://forum.uipath.com/u/aliaga)\ **Replies:** 8\ **Last updated:** [December 27, 2023, 4:57am UTC](https://forum.uipath.com/t/auto-complete-variable-with-default-value/708639 "2023-12-27T04:57:52Z")
Hi All, Currently im working at automation for generate letter in word document. I have had replace activity from Balareva to replace specific word with my variable data, but i have issue with this type of document : … --- ## [Unexpected output regex 22](https://forum.uipath.com/t/unexpected-output-regex-22/706770)
**Author:** [@copy\_writes](https://forum.uipath.com/u/copy_writes)\ **Replies:** 2\ **Last updated:** [December 15, 2023, 2:30pm UTC](https://forum.uipath.com/t/unexpected-output-regex-22/706770 "2023-12-15T14:30:24Z")
HI Team, Hope all are doing well, I am posting this topic because I found some errors while working on the Regex. Error: I try to extract only capital letter and integer values in the given String but the bot is printi… --- ## [Extract text from Text file](https://forum.uipath.com/t/extract-text-from-text-file/687276)
**Author:** [@Beginner1234](https://forum.uipath.com/u/Beginner1234)\ **Replies:** 19\ **Last updated:** [November 9, 2023, 10:24am UTC](https://forum.uipath.com/t/extract-text-from-text-file/687276 "2023-11-09T10:24:07Z")
Hi all, I have a scenario. I’m receiving a text file in that i will be having questions, question options and the answers. Now i need to extract only questions and answers and store them in another text file. How to ach… --- ## [Writting a post and then attaching an image leads the text to disappear](https://forum.uipath.com/t/writting-a-post-and-then-attaching-an-image-leads-the-text-to-disappear/644425)
**Author:** [@pere](https://forum.uipath.com/u/pere)\ **Replies:** 5\ **Last updated:** [October 18, 2023, 8:33am UTC](https://forum.uipath.com/t/writting-a-post-and-then-attaching-an-image-leads-the-text-to-disappear/644425 "2023-10-18T08:33:16Z")
This happened to me 1 minute ago, while reporting a bug in Studio. I wrote a long text and then, when I attached a screenshot and clicked on the “Create Topic” button, it complained the post has to be 100 characters (or … --- ## [How to remove a special characters in a given string by regex](https://forum.uipath.com/t/how-to-remove-a-special-characters-in-a-given-string-by-regex/609494)
**Author:** [@sai\_gupta](https://forum.uipath.com/u/sai_gupta)\ **Replies:** 8\ **Last updated:** [September 27, 2023, 6:49am UTC](https://forum.uipath.com/t/how-to-remove-a-special-characters-in-a-given-string-by-regex/609494 "2023-09-27T06:49:51Z")
how to remove a special characters in a given string by regex? “philippines nt., (Roosevelt Ave 3), St@a. philippines City, @U/SA” --- ## [Regex Alphanumeric and Certain Special Characters](https://forum.uipath.com/t/regex-alphanumeric-and-certain-special-characters/570299)
**Author:** [@anthonyjr](https://forum.uipath.com/u/anthonyjr)\ **Replies:** 6\ **Last updated:** [August 8, 2023, 1:03am UTC](https://forum.uipath.com/t/regex-alphanumeric-and-certain-special-characters/570299 "2023-08-08T01:03:35Z")
Hello fellow RPA Developers, I would like to ask for help for Regex of Alphanumeric and Certain Special Characters. Input: Washington St., (Poblacion 3), St@a. Rita City, “New-York”, U/SA Expected Output: Washington S… --- ## [Typing Italic When Sees Uppercase "i"](https://forum.uipath.com/t/typing-italic-when-sees-uppercase-i/567128)
**Author:** [@emre.polat](https://forum.uipath.com/u/emre.polat)\ **Replies:** 3\ **Last updated:** [July 26, 2023, 2:44pm UTC](https://forum.uipath.com/t/typing-italic-when-sees-uppercase-i/567128 "2023-07-26T14:44:29Z")
Hi Everyone, Recently, i have started learning UiPath and I made an automation. At the end of the processes, robot types a message to the online chat. When a message includes “İ” (uppercase “i”, a Turkish character) it… --- ## [How to highlight text](https://forum.uipath.com/t/how-to-highlight-text/547526)
**Author:** [@Suraj\_Gaikwad\_Nuvama\_Grou](https://forum.uipath.com/u/Suraj_Gaikwad_Nuvama_Grou)\ **Replies:** 3\ **Last updated:** [May 23, 2023, 9:57am UTC](https://forum.uipath.com/t/how-to-highlight-text/547526 "2023-05-23T09:57:56Z")
Hello, I have to highlight specific text EX there is paragraph in that paragraph there is word “Name” and i want to highlights only this word this is my code is regex match pattern =(Sub:)\[\\w\\W\\d\]+(?=India.com) --- ## [Manipulation of date using mail and stored data](https://forum.uipath.com/t/manipulation-of-date-using-mail-and-stored-data/541956)
**Author:** [@Shubham\_Kinge](https://forum.uipath.com/u/Shubham_Kinge)\ **Replies:** 2\ **Last updated:** [May 5, 2023, 4:47am UTC](https://forum.uipath.com/t/manipulation-of-date-using-mail-and-stored-data/541956 "2023-05-05T04:47:07Z")
Hello good morning. I have one scenario can someone please help. Part ive done- I want to read the tabular data from mail store in variable each row i stored it in collection. Confusion- next time when bot runs it sho… --- ## [Convert mail body html to text](https://forum.uipath.com/t/convert-mail-body-html-to-text/535392)
**Author:** [@happyautomaion](https://forum.uipath.com/u/happyautomaion)\ **Replies:** 1\ **Last updated:** [April 13, 2023, 11:12am UTC](https://forum.uipath.com/t/convert-mail-body-html-to-text/535392 "2023-04-13T11:12:56Z")
Hi, How can i get mail body in text format. Mail.Body return to html format. How can i do this with imap activity ? Regards, --- ## [Read Name File With Condition](https://forum.uipath.com/t/read-name-file-with-condition/532575)
**Author:** [@samarasenja](https://forum.uipath.com/u/samarasenja)\ **Replies:** 12\ **Last updated:** [April 5, 2023, 9:01am UTC](https://forum.uipath.com/t/read-name-file-with-condition/532575 "2023-04-05T09:01:26Z")
I have file name : 7. ABCD EFG 170223. txt under the condition 7. is static name ABCD EFG 170223 is dynamic name what if I want to read the filename “7.” only? --- ## [How to Split text to newline when find some key word](https://forum.uipath.com/t/how-to-split-text-to-newline-when-find-some-key-word/529045)
**Author:** [@Harpoon](https://forum.uipath.com/u/Harpoon)\ **Replies:** 4\ **Last updated:** [March 24, 2023, 9:40am UTC](https://forum.uipath.com/t/how-to-split-text-to-newline-when-find-some-key-word/529045 "2023-03-24T09:40:08Z")
i want split text to new line this sample text 40,Mathematics,80,A,50,Adam 40,Data Structure,70,B,50,Armin 40,DataBase,80,A,50,Abigail and i want result like this 40,Mathematics,80,A, 50,Adam 40,Data Structure,70… --- ## [Fetch row excel 3 sheets to 1 sheet](https://forum.uipath.com/t/fetch-row-excel-3-sheets-to-1-sheet/528629)
**Author:** [@Harpoon](https://forum.uipath.com/u/Harpoon)\ **Replies:** 4\ **Last updated:** [March 23, 2023, 3:45am UTC](https://forum.uipath.com/t/fetch-row-excel-3-sheets-to-1-sheet/528629 "2023-03-23T03:45:19Z")
fetch row excel with sample data sheet 1 item st\_name st\_No class adviser 10 manee 10000056 2 byran sheet 2 item subject point Grade 20 Mathematics 80 A 20 Data Structure 70 B 20 DataBase 80 A sheet 3 ite… --- ## [Removing brackets \[\] inside a string](https://forum.uipath.com/t/removing-brackets-inside-a-string/524365)
**Author:** [@madhabhazra0](https://forum.uipath.com/u/madhabhazra0)\ **Replies:** 8\ **Last updated:** [March 10, 2023, 4:51pm UTC](https://forum.uipath.com/t/removing-brackets-inside-a-string/524365 "2023-03-10T16:51:11Z")
I have the following string: “- \[RPUIN-01/31/2023 12:38:32 PM\] Contact ABC TEST - \[ TEST UIPOMIN-01/31/2023 12:38:52 PM\]” I only want to have the part outside the brackets: “Contact ABC TEST” I’m not able to remove t… --- ## [How can ı delete space between words in text file? How can create a list and insert the elements into it?](https://forum.uipath.com/t/how-can-i-delete-space-between-words-in-text-file-how-can-create-a-list-and-insert-the-elements-into-it/518518)
**Author:** [@Burak\_Oksuz](https://forum.uipath.com/u/Burak_Oksuz)\ **Replies:** 1\ **Last updated:** [February 19, 2023, 3:58am UTC](https://forum.uipath.com/t/how-can-i-delete-space-between-words-in-text-file-how-can-create-a-list-and-insert-the-elements-into-it/518518 "2023-02-19T03:58:22Z")
I want to select the words in a text file and print them to the excel file according to their meaning. There are spaces between the words. I don’t know how to delete the spaces. I’m having trouble using commands like to… --- ## [Txt content to sql query](https://forum.uipath.com/t/txt-content-to-sql-query/506844)
**Author:** [@koolrc812](https://forum.uipath.com/u/koolrc812)\ **Replies:** 0\ **Last updated:** [January 12, 2023, 6:31am UTC](https://forum.uipath.com/t/txt-content-to-sql-query/506844 "2023-01-12T06:31:18Z")
Hi I got below sql query. for customerId is also changeable depends on each time text content’s value. how do I write customerId as a variable? if phoneNo and customerId both have no result in SQL. eg. if phoneno … --- ## [Retrieve results from a Json string](https://forum.uipath.com/t/retrieve-results-from-a-json-string/484127)
**Author:** [@Dhruvi\_Arumugam](https://forum.uipath.com/u/Dhruvi_Arumugam)\ **Replies:** 12\ **Last updated:** [October 28, 2022, 12:50pm UTC](https://forum.uipath.com/t/retrieve-results-from-a-json-string/484127 "2022-10-28T12:50:52Z")
Hi Everyone, Need some help in obtaining the values out of a Json String, below is the string { "Output": \[ { "Desc": "\*\*This is a Test Change Request No action is required\*\* HHC Remediation", … --- ## [Text file manipulation](https://forum.uipath.com/t/text-file-manipulation/467229)
**Author:** [@Zaw\_Win\_Htun1](https://forum.uipath.com/u/Zaw_Win_Htun1)\ **Replies:** 9\ **Last updated:** [August 24, 2022, 8:27am UTC](https://forum.uipath.com/t/text-file-manipulation/467229 "2022-08-24T08:27:07Z")
Dear Experts, I converted pdf data into text files and in the pdf the data is formatted as columns. When converting text file, some of the data is placed in the wrong column. How can I get the data as the requirement. I… --- ## [How to configure custom column in generate data table](https://forum.uipath.com/t/how-to-configure-custom-column-in-generate-data-table/465989)
**Author:** [@Zaw\_Win\_Htun1](https://forum.uipath.com/u/Zaw_Win_Htun1)\ **Replies:** 11\ **Last updated:** [August 19, 2022, 3:27am UTC](https://forum.uipath.com/t/how-to-configure-custom-column-in-generate-data-table/465989 "2022-08-19T03:27:01Z")
Hello Experts, How can we solve this issue? I convert pdf files into text files and then generate data table to get datable. But the generate data table output is not formatted as I want. This is the generated data us… [Next page](https://forum.uipath.com/tag/text/1775.md?match_all_tags=true&page=1&tags%5B%5D=text)