[Solved] How to Trim Text of a string in C# or in SQL query.

Question

3.50/5 (2 votes)

See more:

Hi guys,

I have the following sql query:

C#

"select task_attachment_path \"File Name\" from AttachmentTable";

I got the output in my gridview's cell as:

| File Name |
| ====================================== |
| D:\Live CMS\requestAttachments\23101\Development File.txt |

I want to show only File Name in my Gridview Cell like 'Development File.txt' only.
Can I apply any kind of function in my SQL query or how can I handle it in my C# code.

Please help !!!

Thanks,
AR

Posted 18-Dec-13 0:37am

AR547

Updated 12-May-14 1:08am

v3

Add a Solution

5 solutions

Solution 4

visit here...

http://msdn.microsoft.com/en-us/library/t97s7bs3%28v=vs.110%29.aspx[^]

or

http://www.w3resource.com/sql/character-functions/trim.php[^]

Posted 18-Dec-13 1:16am

Rakesh Meel

Comments

Maciej Los 18-Dec-13 7:20am

Please, read question carefully. OP wants to extract the name of file from path. Improve your anwer, OK ;)
Note: i'll not vote till that time.

[no name] 18-Dec-13 7:22am

k.....Thanks...

Solution 2

You can use SUBSTRING[^] in sql.

e.g

SQL

select substring('select task_attachment_path \"File Name\" from AttachmentTable',31,9)

Posted 18-Dec-13 0:44am

Snehasish_Nandy

Comments

Maciej Los 18-Dec-13 7:01am

The length of path may be differ...
Do you know what i mean?
;)
[EDIT]
Please, see my answer.
Note: I'm not down-voted your answer
[/EDIT]

[no name] 18-Dec-13 7:32am

i know it may differ..i just gave as an example..

Maciej Los 18-Dec-13 7:53am

Up-voted, because of AR547 answer!

AR547 18-Dec-13 23:39pm

substring, replace, ltrim, rtrim they all can work in sql query to get the specific text/character from a string.
Just learned yesterday :D

Solution 3

Test it:

SQL

DECLARE @ffilename VARCHAR(255)
SET @ffilename = 'D:\Live CMS\requestAttachments\23101\Development File.txt'

SELECT REVERSE(LEFT(REVERSE(@ffilename),CHARINDEX('\',REVERSE(@ffilename))-1)) AS ShortFileName, @ffilename AS FullFileName

Result:

ShortFileName           FullFileName
Development File.txt	D:\Live CMS\requestAttachments\23101\Development File.txt

Posted 18-Dec-13 1:10am

Maciej Los

Updated 18-Dec-13 1:11am

v2

Comments

Karthik_Mahalingam 18-Dec-13 7:41am

excellent +5!

Maciej Los 18-Dec-13 7:52am

Thank you ;)

AR547 18-Dec-13 13:13pm

awesome

Maciej Los 18-Dec-13 15:17pm

Thank you ;)

BK 4 code 19-Dec-13 6:54am

its not a big deal

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CPallini · Accepted Answer · 2013-12-18T00:43:00

Solution 1

Use the Path.GetFileName[^] method (see the sample code in the documentation page).

Posted 18-Dec-13 0:43am

CPallini

Comments

Maciej Los 18-Dec-13 6:59am

+5
Please, see my answer ;) I'm using SQL only.
Our solutions complement each other.

CPallini 18-Dec-13 7:11am

Thank you.

Karthik_Mahalingam 18-Dec-13 7:41am

good answer

CPallini 18-Dec-13 7:56am

Thank you.

AR547 18-Dec-13 23:38pm

(y) Good clue.. :)

AR547 · Accepted Answer · 2013-12-18T01:22:00

Solution 5

C#

"select replace(TASK_ATTACHMENT_PATH,'D:\\Live CMS\\requestAttachments\\23101\\') from TABLE";

The Function of REPLACE worked perfect in this scenario in SQL Qyery.
It gave me only text after \23101\ which I needed to display.

:)

Thanks to all for great work too.

Posted 18-Dec-13 1:22am

AR547